Tabela Co_L_OrderItemProduction

Definicja tabeli Co_L_OrderItemProduction

Name

Co_L_OrderItemProduction

Code

Co_L_OrderItemProduction

Comment

Tabela linkujaca OrderItemy z produkcjai lotami


Lista kolumn tabeli Co_L_OrderItemProduction

Name

Code

Co_L_OrderItemProductionId

Co_L_OrderItemProductionId

LotId

LotId

Co_OrderItemId

Co_OrderItemId

Co_ProductionId

Co_ProductionId


Kolumna Co_L_OrderItemProductionId tabeli Co_L_OrderItemProduction

Definicja kolumny Co_L_OrderItemProductionId tabeli Co_L_OrderItemProduction

Name

Co_L_OrderItemProductionId

Code

Co_L_OrderItemProductionId

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna LotId tabeli Co_L_OrderItemProduction

Definicja kolumny LotId tabeli Co_L_OrderItemProduction

Name

LotId

Code

LotId

Data Type

NUMBER(10)

Mandatory

No

Comment

identyfikator lotu z apteki (tabela PhLot)


Kolumna Co_OrderItemId tabeli Co_L_OrderItemProduction

Definicja kolumny Co_OrderItemId tabeli Co_L_OrderItemProduction

Name

Co_OrderItemId

Code

Co_OrderItemId

Data Type

NUMBER(10)

Mandatory

No

Comment

identyfikator powišzanego OrderItemId (tabela Co_OrderItem)


Kolumna Co_ProductionId tabeli Co_L_OrderItemProduction

Definicja kolumny Co_ProductionId tabeli Co_L_OrderItemProduction

Name

Co_ProductionId

Code

Co_ProductionId

Data Type

NUMBER(10)

Mandatory

No

Comment

identyfikator produkcji (tabela Co_Production)


Lista kluczy tabeli Co_L_OrderItemProduction

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Co_L_OrderItemProduction

Definicja klucza Identifier_1 tabeli Co_L_OrderItemProduction

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment